﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using MySql.Data.MySqlClient;
using Cinemon.MySqlConnect;

public partial class License_View : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        using (DatabaseManager manager = new DatabaseManager())
        {
            DataTable table = manager.ExecuteQuery("GetAllLicenses");
            gvLicense.DataSource = table;
            gvLicense.DataBind();
        }

        using (DatabaseManager manager = new DatabaseManager())
        {
            DataTable table = manager.ExecuteQuery("getLicensesExpired");
            exView.DataSource = table;
            exView.DataBind();
        }
    }
    protected void gvStaff_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
    }
    protected void gvLicense_SelectedIndexChanged(object sender, EventArgs e)
    {
        gvLicense.Visible = false;
    }
    protected void btnStaff0_Click(object sender, EventArgs e)
    {
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        Response.Redirect("add.aspx");
    }
    protected void gvLicense_RowEditing(object sender, GridViewEditEventArgs e)
    {
        
    }
    protected void gvLicense_SelectedIndexChanged1(object sender, EventArgs e)
    {
        
    }
}